<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882">
    <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
        <Author>linxs</Author>
        <Created>2019-04-07T14:34:08Z</Created>
        <LastSaved>2019-04-07T16:05:32Z</LastSaved>
    </DocumentProperties>
    <CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
        <KSOProductBuildVer dt:dt="string">2052-1.0.0.1113</KSOProductBuildVer>
    </CustomDocumentProperties>
    <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
        <WindowHeight>16700</WindowHeight>
        <ProtectStructure>False</ProtectStructure>
        <ProtectWindows>False</ProtectWindows>
    </ExcelWorkbook>
    <Worksheet ss:Name="Sheet1">
        <Table ss:ExpandedColumnCount="100" ss:ExpandedRowCount="${result?size+2}" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54.4" ss:DefaultRowHeight="13.6">
            <Column ss:Index="2" ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="68.35"/>
            <Column ss:Index="4" ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="106.65"/>
            <Column ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="103.3"/>
            <Column ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="116.65"/>
            <Column ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="106.65"/>
            <Row>
                <Cell>
                    <Data ss:Type="String">订单编号</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">商户名称</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">商户联系人</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">商户电话</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">收货人</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">收货电话</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">收货地址</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">下单时间</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">订单总价</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">支付方式</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">支付状态</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">订单状态</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">商品名称</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">商品数量</Data>
                </Cell>

            </Row>

        <#list result as item>
            <Row>
                <Cell>
                    <Data ss:Type="String">${(item.orderNo)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.merchant.shopName)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.merchant.realName)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.merchant.mobile)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.deliveryName)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.deliveryMobile)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.deliveryProvince)! }${(item.deliveryCity)! }${(item.deliveryArea)! }${(item.deliveryAddress)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.createTime?string("yyyy-MM-dd HH:mm:ss"))! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.price?string('0.00'))!}</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String"><#if (item.payMethod)! == 1>微信<#elseif (item.payMethod)! ==2>支付宝<#elseif (item.payMethod)! ==3>余额</#if></Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String"><#if (item.payStatus)! == 1>已支付<#else>未支付</#if></Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String"><#if (item.status)! == 1>待付款<#elseif (item.status)! ==2>待发货<#elseif (item.status)! ==3>待收货<#elseif (item.status)! ==4>待评价<#elseif (item.status)! ==5>交易完成<#elseif (item.status)! ==6>已取消</#if></Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.expressCompany)! }</Data>
                </Cell>
                <Cell>
                    <Data ss:Type="String">${(item.goodsQuantity)!}</Data>
                </Cell>
            </Row>
        </#list>
        </Table>
        <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
            <PageSetup>
                <Header x:Margin="0.511805555555556"/>
                <Footer x:Margin="0.511805555555556"/>
            </PageSetup>
            <Selected/>
            <TopRowVisible>0</TopRowVisible>
            <LeftColumnVisible>0</LeftColumnVisible>
            <PageBreakZoom>100</PageBreakZoom>
            <Panes>
                <Pane>
                    <Number>3</Number>
                    <ActiveRow>9</ActiveRow>
                    <ActiveCol>6</ActiveCol>
                    <RangeSelection>R10C7</RangeSelection>
                </Pane>
            </Panes>
            <ProtectObjects>False</ProtectObjects>
            <ProtectScenarios>False</ProtectScenarios>
        </WorksheetOptions>
    </Worksheet>
</Workbook>